SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473814 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473814 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250258,343318,462468,190530,281078,900245,19613,67471,1044276,889022,608169,385754,935219,633785,313519,722842,656408,464125,425748,959303,591978,514418,205434,837562,224624,950482,966758,92756,745646,270390,162577,1033215,66618,306402,158308,833549,815403,536108,85458,407314,291068,240441,655814,970009,568012,991874,930179,494227,564751,765954,446561,445685,136483,1016708,44509,433912,950260,469595,528820,465744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]