SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401643 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401643 [ RunTime:0.001456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317849,630519,422195,257903,945851,252366,575334,833546,973584,409734,210563,721604,179306,220321,238021,454302,828440,1017239,856825,534972,238386,61269,512609,217526,166648,1031106,576614,591851,200761,433267,661129,61384,741669,717595,744497,947025,299411,866100,936970,988085,258040,724664,869031,942049,161332,1044070,333086,1041177,35902,589594,9689,880557,365947,663150,467400,832882,556593,828706,510284,426096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]