SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505473 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505473 [ RunTime:0.002892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391845,935512,40404,646470,1014403,721791,903333,299558,142514,23133,325982,140738,696421,251125,1009435,150593,245304,119776,255969,693908,530287,800429,35646,439355,77591,314235,15572,199601,273939,241891,876201,825099,823441,761476,669725,781103,246080,946670,664167,308479,215904,838924,1044407,639838,520142,571031,656483,382943,138010,402706,308434,792118,704342,599903,437449,605592,498122,544520,17568,211458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]