SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 210142 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 210142 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504535,105989,784409,40183,814293,66286,169149,505550,371558,498003,288239,796112,904260,472295,614186,810588,267112,953798,971724,285581,630133,470818,1043686,888054,919988,447814,171154,846625,474730,537802,74412,1001965,511406,972125,991259,645523,772514,394002,362818,591220,190664,914709,728791,836357,721534,869892,745418,460087,611569,243161,99549,538175,653585,22892,559658,1034555,817527,307919,569531,465670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 210142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 210142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]