SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046011 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046011 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57254,236463,12843,235371,962381,336781,732088,293388,925570,453167,711814,829341,107594,30818,1045928,250965,89255,277814,807368,434442,20038,767132,40819,574721,437283,221935,736894,230829,731005,934714,504313,316924,1004828,584731,191979,5849,883594,1019605,628874,255354,794904,308254,201846,932197,765814,248547,87677,162574,601626,392910,312127,346089,6981,248067,414935,1006075,1022631,1028107,1003333,388943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001357s ]