SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414826 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414826 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57150,278379,292539,593975,168230,1039028,415249,566112,134108,188554,894351,877102,357204,438548,143218,823889,777007,1048230,347349,1004911,733110,541687,590761,506626,217167,380460,104228,663630,724696,543429,255215,48884,968465,858956,996285,533790,653192,882048,154127,865572,408316,175242,874434,900692,293098,140319,566637,21426,925658,275199,531766,1019822,433959,893733,728325,741224,85577,571967,395515,905992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]