SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007570s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20545 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20545 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400791,493350,1008812,675116,173364,829250,733059,540052,588839,407281,610299,595625,129339,211159,394883,355980,599545,999548,672318,1048101,233406,410389,222704,147768,607156,468194,74744,574182,88956,442179,298890,716959,822570,941317,533608,955718,800929,730001,469475,2398,6417,909776,597380,1025850,107477,55390,259121,242349,961982,991441,571345,155459,1031068,989580,1007435,759254,250460,552865,946853,478464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001871s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]