SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346215 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346215 [ RunTime:0.002133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489041,433173,535425,76368,120366,244582,644550,995631,690446,923716,399541,318440,791288,422975,555637,627184,429716,149347,940623,308248,340050,39825,731745,365827,909516,465701,380856,542812,712847,221848,407112,369501,1039768,625335,763870,374743,862220,707732,83397,311926,245858,817363,947688,720988,152042,623557,134718,783248,847703,964807,764542,111731,249252,428487,583962,495410,167052,43217,251073,698519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]