SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444618 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444618 [ RunTime:0.004323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936766,208785,206939,195219,340463,708230,608613,883601,501313,163369,247927,80252,55132,917240,339360,1015627,755121,621984,263791,113739,505502,177090,197253,947885,1027634,266791,136651,927428,228906,344587,41556,767993,185724,871547,173594,760384,435338,536828,711721,1042680,428644,881816,651440,686444,410466,317005,249822,1033749,721260,25907,219487,948676,994181,758617,693780,748688,704803,78087,289564,92427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]