SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414178 LIMIT 1 [ RunTime:0.001773s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414178 [ RunTime:0.003939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269047,973912,472906,847332,35797,596112,993657,108050,448972,787561,67208,529187,985269,638108,855510,644021,574863,18403,834155,734919,819392,180374,146700,570204,74262,209165,230975,644987,72253,469926,30922,350818,341369,203949,411549,924799,857094,90391,814985,545247,686342,66190,409385,551858,342268,894240,486894,602774,369362,1004015,637789,642961,530396,1046335,550984,535537,606799,187277,727363,227652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001188s ]