SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001654s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326406 LIMIT 1 [ RunTime:0.000984s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326406 [ RunTime:0.002411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896684,374551,917948,524907,362630,50251,495365,809425,380861,64312,74893,1012239,599696,209214,531490,375704,493694,674025,108410,546492,1029298,494273,160518,305327,398659,437896,241491,949220,980719,55817,865723,596541,663976,212362,194986,481796,642023,943718,788453,243860,178729,975836,540107,184037,129201,71084,927352,504354,1026005,344659,2493,872676,581187,85002,685078,574644,64141,162563,314055,319821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]