SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530526 LIMIT 1 [ RunTime:0.003778s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530526 [ RunTime:0.003328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489495,251279,28835,771912,490433,215457,8695,1015089,506984,649987,864908,138300,1029908,408147,365857,974933,308181,226218,449916,831618,518717,673630,256445,1031494,99513,943347,410793,49362,998558,703260,1046971,412384,9723,965713,450330,619640,134688,727277,239123,32951,741655,53325,105231,495902,90932,508289,970424,197561,605719,227979,620194,882017,116310,1003524,8518,768209,214436,982749,842882,32439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]