SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001776s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017040 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017040 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830796,222750,428111,599638,384054,757548,318259,156954,1016517,885246,199099,905434,662228,813369,70691,117323,951956,520208,416016,347157,859141,791555,152477,892186,865500,559309,748855,376376,312664,358284,851620,167167,150019,517136,694289,783389,535505,681996,370315,1040896,91934,809875,423236,339313,919106,842350,102640,707447,944281,949417,962138,805631,1027573,241957,404450,5870,1029740,34288,96157,442064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]