SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503710 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503710 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524497,945324,710807,583389,627230,873004,192278,1028545,340980,1024335,189136,280943,184746,146742,418752,570549,1042929,90793,378263,446142,687997,387729,320094,771328,501200,120197,1023733,121907,356441,152657,731709,217232,502157,537454,278705,970239,177057,40194,420178,818311,125143,747687,489256,711682,1042419,936006,537242,590234,983103,578066,337268,1035663,352846,1036277,805037,584935,643948,905074,64151,797970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]