SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487508 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487508 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725671,166582,869555,980104,979901,668399,840463,681104,243891,96605,224265,135799,228188,814582,632547,121450,419899,88744,539100,928176,43632,334609,224350,578755,484264,724528,1041799,367954,743281,745109,90402,254336,855949,373711,213736,197201,305562,513352,210491,14765,908772,831738,161361,907006,643413,778187,997364,467383,806457,1032365,956533,611495,248643,66329,338929,872965,70139,594987,204190,50107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]