SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443409 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443409 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824370,760654,918579,206227,866667,109987,784269,573529,894120,133501,213449,31743,254937,930921,519572,119554,541751,1030028,891914,686961,130062,970471,140200,508263,229074,1013617,891727,203440,5564,548341,39589,17416,960253,362706,804417,416520,274157,363995,812343,304339,670460,1020087,646158,776534,351282,969548,42545,399356,172316,451093,801121,134612,661885,125612,195387,857573,972648,240305,292585,866614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]