SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354181 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354181 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429753,831396,669267,796109,914485,608221,249889,669552,519446,232176,642527,553617,957381,1006237,490231,462640,109689,755592,692304,416386,795122,83188,441006,145464,193166,854870,97702,499578,456097,508143,747358,478752,47252,941612,613028,726658,887148,847820,493532,483101,362881,976771,76040,812920,798894,984165,178651,465430,326500,743105,24453,566299,823091,939141,743594,283112,832503,621141,104758,287480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]