SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391978 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391978 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65369,990097,926202,570806,952420,252527,799653,515694,644203,447781,624394,454580,984152,995651,1014608,1036367,50042,797394,760535,594233,833995,37086,98740,761719,228534,901990,1021403,235858,267842,83048,601723,80311,268892,248972,382665,888638,203060,131493,964720,238581,538526,378793,963582,692738,659729,476709,675336,174127,675828,1032121,924687,334644,540983,655312,149765,984282,349761,191126,658753,995972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001062s ]