SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36190 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36190 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554558,556147,410053,249611,74225,256037,1019904,437912,488181,154659,912190,481899,900275,619095,1035657,588713,432928,575228,938202,701317,659040,320166,258824,16388,120162,821560,922529,644949,615211,132439,947295,590336,383550,469713,1003851,214991,549569,842638,447585,625315,1033635,831296,563717,46855,953733,372355,404403,889492,116016,327065,306768,3878,1001713,246519,329588,804680,435861,310555,80390,301190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]