SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201025 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201025 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910226,813178,747677,1012866,1005381,497277,392783,263751,68538,351533,850662,970421,428313,337743,913017,475415,483766,321768,229843,237470,1044730,245229,419861,876584,958483,696889,800790,52722,565594,881700,955162,973727,371877,160323,473196,211985,49344,481451,773183,928279,949322,964817,847483,363463,935489,530149,644188,606873,123531,1046647,1036663,891207,503062,112689,572580,505767,761090,459604,597803,516902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]