SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381213 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381213 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79026,393888,165993,963599,209750,771536,239117,66728,367536,743874,447805,175095,483758,622010,111520,511018,155140,284825,385396,567472,343529,609598,445401,6641,140106,819470,303258,603845,44387,95126,893782,937443,390122,23788,1034890,768498,526245,770343,427620,450553,556132,541809,384524,884228,391648,712096,814035,374612,47443,945706,649133,478262,158891,373919,442091,88893,202293,68748,290117,1041900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]