SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417270 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417270 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536584,591940,354287,385053,904918,727846,399462,964018,408168,118720,685017,460768,364282,914647,138238,1042840,712367,279708,997737,89050,959772,866684,551356,71652,320529,158484,384424,28529,899073,330094,1021270,520669,428571,159433,279075,515702,688014,322108,832388,833499,629607,73642,659426,722089,846663,586189,264730,252621,721666,887639,898248,296999,345617,166516,609138,360724,494631,724637,787990,362080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]