SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803441 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803441 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489374,1013022,25814,409651,973258,827665,43523,546247,264400,340784,606594,1043246,915895,892713,418227,626179,819162,21468,317250,148684,416534,275834,316663,441515,65094,310369,599919,300563,944411,588554,216461,735878,147972,842896,1011035,906289,599005,319842,600597,160094,975723,90366,90406,752296,936589,963316,937222,856793,744437,58856,367142,230450,940601,454779,789539,203260,542342,978547,569981,31014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]