SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031604 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031604 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52974,583876,603219,1029946,79409,499719,246524,264933,179422,1004667,7473,968704,909415,888798,595682,608383,597694,603289,549710,44700,325052,682472,414416,509090,230922,139574,780175,676362,548157,722932,596262,471142,428398,998977,145811,92511,653647,881155,440146,410160,590135,479914,76620,407544,530813,54444,387765,461802,46896,883121,438230,528633,39392,264988,128441,304133,340109,821336,372864,213626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]