SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 712012 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 712012 [ RunTime:0.003566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023837,100613,188277,628399,1021528,732460,267802,593798,510972,633096,129849,587678,950629,992607,97427,377545,993109,426846,141847,517171,1016131,84739,660638,154827,472352,1019849,302423,581198,650062,750175,560667,433341,594087,612281,256098,936536,818050,535358,702343,843937,485505,376172,22217,955955,1014436,717214,598682,14140,41260,1047116,439396,765440,607823,327848,236687,489333,86379,926441,715783,645561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 712012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 712012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]