SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535202 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535202 [ RunTime:0.001933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968496,662659,585208,461421,180115,543128,342912,676973,436064,575242,94580,485100,831374,1043503,381966,644588,664904,224779,568649,173261,136937,397653,857971,626948,393589,620476,922797,410822,879282,521510,435910,257049,15253,498930,325124,278427,30875,706322,94322,396266,627083,216090,957213,559067,610741,858835,904354,167522,816049,721501,525162,624144,562490,692880,582748,782486,188116,62835,724855,481392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]