SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484685 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484685 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436910,618971,7101,941206,773573,620500,228994,475471,791157,850472,36170,995439,934344,809640,873210,36451,615522,640450,826490,534769,84159,850410,72253,311414,86387,1015905,452818,1019627,851769,881477,728403,136107,116833,454286,898779,736571,765687,1028918,523529,22007,1017123,529682,97150,440818,378771,1009631,753470,725037,165311,649675,30127,519301,165572,620233,722053,167846,888451,711616,936357,47730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]