SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005328 LIMIT 1 [ RunTime:0.000957s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005328 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71240,282784,986163,348893,770356,602902,830820,416716,1042740,474323,1022954,761810,432951,143127,296765,44502,322715,1007936,332257,814741,607104,461899,100832,361754,67837,854931,187656,687874,117918,236698,825874,1036382,423883,234327,189794,247907,374809,469721,447269,596952,886960,93160,442827,225914,184517,420546,198326,51340,947316,584310,410245,222348,762554,902232,919995,312354,549133,995257,378527,487309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000942s ]