SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803028 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803028 [ RunTime:0.002765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416110,398794,141408,629150,1041112,573095,873939,685524,826728,461471,481081,736220,237509,601318,383624,84448,215556,717238,740895,983177,54352,776689,406886,403464,114091,230085,442006,495306,162487,766967,244766,104104,922792,744522,73255,48691,261849,997237,102782,486087,662809,803686,60913,857500,91827,848579,157165,476529,632369,471702,582135,796602,475615,120495,715136,497500,403593,959847,412199,654033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]