SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343161 LIMIT 1 [ RunTime:0.001603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343161 [ RunTime:0.002144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671039,781500,585178,459295,741491,1044442,990700,737559,405764,236996,554295,460026,139640,868607,708381,298775,688111,293538,704000,154892,687000,225910,660234,483666,697385,428927,74022,842290,95514,172467,669278,165223,606121,105168,735742,548201,393712,471582,732248,267252,114660,134491,377247,591793,615127,667970,737724,527387,413708,972322,882438,27048,498693,52565,28714,354147,314939,32682,243813,282185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002899s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002830s ]