SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555623 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555623 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70131,698204,279272,701429,487597,854383,138898,494977,1044667,738011,563542,900953,809053,244193,960402,78832,671203,1008466,982776,116734,860700,759231,175497,114176,935313,199381,655982,96618,37054,474451,744730,1008259,197893,830095,605787,191855,530002,294865,373608,32624,712156,728367,920518,502277,956987,364481,756052,912510,973542,381291,304339,1019513,128559,267570,198536,983230,80160,587072,145055,264833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]