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` = 20130 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20130 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154681,1034247,827768,994522,1002620,364920,589126,656820,492579,679715,105624,246680,228703,393037,684433,333588,469034,620692,495466,662128,181889,249272,941089,816902,639716,61144,928125,390815,969568,468518,1020746,140966,124751,166169,639943,326124,210761,165067,751240,239992,912826,38979,382180,878713,494300,810740,1021416,239434,432585,132800,1013236,500169,998296,380767,811262,821035,459902,456224,845529,1013500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20130 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20130 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]