SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 362082 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 362082 [ RunTime:0.002919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530339,954876,836911,53368,960639,171015,10833,788980,42847,55391,910608,73064,953989,750018,241497,356007,406719,685647,781067,540993,358844,124836,841285,106670,993578,1024309,471440,920636,940907,723920,658688,108546,992804,860250,1002323,279528,1022362,255711,598420,216907,271349,305662,878228,122156,978000,681971,349647,930281,1021910,310096,651379,202855,1010063,1046097,652901,847413,835851,1044922,682560,785445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 362082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 362082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]