SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519209 LIMIT 1 [ RunTime:0.000667s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519209 [ RunTime:0.002893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906935,967753,394392,57966,807490,338805,535657,440034,888552,761137,204355,323380,652935,58473,113270,248375,937557,438217,963478,275327,70,907203,193181,370191,383604,19952,631485,1011037,526748,121440,668712,429631,1003185,823497,241602,696324,149654,279511,252957,580130,1011889,370181,912269,883978,348577,129404,859925,851481,955386,485827,967000,406532,967101,724406,325419,112450,263225,605950,303913,50028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]