SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 609218 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 609218 [ RunTime:0.001362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282950,642864,381206,1039411,569259,911314,82289,1021621,863398,140101,250347,131419,760278,75023,841807,350656,268098,475026,712793,44722,872441,977982,671243,407006,1039265,546745,859937,366337,778119,788000,77380,549966,709914,204795,419098,563194,350313,862079,405948,441618,230095,943068,405331,4333,241525,555631,14695,660436,674618,537791,252349,880647,66088,591151,999281,557838,430141,1007961,761140,923829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 609218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 609218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]