SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39406 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39406 [ RunTime:0.001859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212280,121361,298034,231657,662454,534572,190566,798503,76202,724274,415645,1025791,785862,880632,861256,847301,716972,624739,128181,779082,498041,852358,896713,175462,907237,140598,848615,578101,873123,19298,1009148,29609,998350,142424,367443,30627,150330,639956,694958,468043,1045677,873496,738422,58963,801564,549163,449275,638758,501109,668548,19466,582000,83748,816389,965414,125358,5529,955543,267432,20964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]