SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028935 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028935 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141194,930172,963464,624866,379185,971336,407687,128687,65765,933075,980941,819752,542287,1034602,919719,879100,1009823,473535,2468,524849,723686,970416,1007888,1959,561013,1028643,688557,555451,532562,651565,1009760,84837,271595,297485,705882,768699,395968,275991,594831,742219,801191,262353,935815,129979,265571,633923,613655,420290,940833,507597,1023720,505434,353153,188211,567743,290401,808733,452927,457325,1005235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002239s ]