SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564415 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564415 [ RunTime:0.003863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814474,229583,184987,556434,200837,317520,279700,526596,100951,447805,930567,955842,145546,498898,944429,200134,521752,29110,384980,444794,775524,277842,281162,313765,971323,549424,245072,322809,206927,62776,942579,730997,71166,510149,482554,246871,600349,61601,268653,1008055,802019,391526,417299,378163,279405,705202,466677,393747,1047410,669496,887823,788136,649851,1031963,438936,600158,983895,454119,69834,899122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]