SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329464 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329464 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539371,625447,698520,291709,139666,942189,719521,245394,313742,413208,846073,864941,830672,424329,314296,77664,380413,674731,1038272,378296,934611,349917,462840,363592,104303,444739,493057,256021,1031794,781558,33215,52837,342527,427719,468697,1027231,193402,671656,186106,680503,552456,976798,275244,156154,502755,22178,967840,461896,199091,641304,392373,25747,832937,988318,497562,971616,221724,979064,539811,707533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329464 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329464 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]