SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501893 LIMIT 1 [ RunTime:0.001537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501893 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324084,1021327,172194,698936,1030698,474197,865843,349715,1031187,634077,881383,620122,857989,979342,184663,698718,335425,5368,400050,238084,892532,543085,505632,649714,597477,838101,978353,738083,761170,283584,932168,511700,747380,907997,251492,265038,1039906,918443,752089,283891,388541,206781,1025045,646260,702402,754038,391634,305556,1040557,1016270,535038,824290,533110,372971,64358,515742,983072,636800,775502,476689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]