SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461032 LIMIT 1 [ RunTime:0.000271s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461032 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742677,1011161,634081,356980,222296,139067,112916,59182,890629,381177,117636,95509,86815,561000,386828,312056,238103,522091,354824,332313,209515,329178,1039650,204809,516860,804285,475844,559197,483624,565861,628071,567167,335518,25901,517060,130117,654368,910240,339159,123297,361311,1041565,233425,307806,92176,368629,871922,912963,560079,738962,327664,20394,386418,607007,460340,492626,426190,802998,734131,85013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]