SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433433 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433433 [ RunTime:0.003310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314993,377117,379850,132129,535662,138517,1029250,491810,546962,220110,513342,1037429,578175,419944,11953,865819,621177,954160,773140,902435,159513,870345,289792,1023622,572972,356802,747019,768055,714656,686701,40360,194545,779589,5443,529248,314258,774134,871381,378356,1046368,454576,265736,884312,572658,648880,25883,687662,616793,13375,389332,694038,594463,954339,600766,672718,384582,536146,200659,145298,224708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001737s ]