SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434018 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434018 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293748,144635,1018281,904436,778795,109452,171049,848059,454770,907478,659105,261675,140686,336779,711971,288773,28928,259277,192850,582165,23881,172297,230112,970827,535651,791958,662404,682918,70071,765687,970707,1010892,315767,92311,490581,924191,829313,942240,497207,826619,305848,755567,859763,99204,693515,653441,902262,536180,594247,960831,985079,777603,812804,32011,809097,778545,602302,1037790,32593,202706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]