SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171415 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171415 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600974,662088,979349,374575,275332,229838,970372,814011,47685,93478,13213,640671,787849,25348,254458,216491,822655,571911,87693,282589,1042819,222982,483545,955522,344516,422016,579597,272142,804565,556141,77065,522087,351414,13094,875676,811530,460880,284331,33012,323001,706949,953170,217106,405860,338174,793631,80884,1014788,750172,21883,288654,989323,17703,788470,102036,717992,948901,436934,467742,640815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001106s ]