SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266015 LIMIT 1 [ RunTime:0.001110s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266015 [ RunTime:0.001305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237136,724495,909311,45972,100893,579914,254502,365720,300043,499078,73649,207528,806258,836047,688413,1005868,365107,160152,419079,350048,17579,503910,955649,184332,736718,691538,409282,171287,978049,827246,518293,424487,509278,1031952,257510,813544,400032,166334,64429,700196,323817,862447,676197,595743,37171,979564,225999,28442,767638,479486,652336,252827,93238,492626,959548,290898,542013,364533,507970,409093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]