SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200854 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200854 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574373,368434,354343,665439,361948,354165,488139,116842,55726,296982,711487,927601,246924,130163,713919,962570,894469,217016,23298,907732,230526,805294,108641,113865,252228,790180,116095,455868,46457,1039279,967604,806102,186739,721709,316522,868754,691472,205724,639024,103179,19561,372501,587848,209499,233841,865439,776969,261061,780420,819952,615539,897298,972251,578733,835428,160438,736457,444349,914179,500084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]