SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002513s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023141 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023141 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228488,315511,577134,966752,1023926,519611,1007613,776583,579137,331453,266883,788847,21912,571074,372488,643753,369222,679716,161970,481089,654768,487384,981441,183070,235952,74537,661417,70788,903536,291273,724446,10764,514176,522269,122962,446038,795688,370914,177832,881858,1046772,1010884,384229,502874,618302,229216,201518,656087,213332,998655,545601,822951,422652,436266,977137,409796,583016,384053,81427,959651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]