SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344527 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344527 [ RunTime:0.001291s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724120,805693,34249,940408,211437,389474,388078,7896,681115,494488,227011,325384,738568,407703,614417,919468,1016315,588730,246513,470005,1046556,984125,583718,111569,842005,148705,594212,593144,64276,71190,499352,446386,756645,963235,444500,339224,789459,724260,973669,814350,712961,66477,397897,357504,110117,317800,923185,828588,1011473,285950,827717,868036,305734,787021,327984,616596,997514,605952,965068,258163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]