SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559251 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559251 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382733,501134,421665,140997,731044,10802,635688,633194,814410,116774,679126,982752,634168,590906,757996,685010,881714,262779,569189,975873,571818,197497,98164,329573,40544,204137,89093,879214,156789,525934,26844,293268,1001895,268514,62372,639404,449873,490944,282323,167559,517786,778665,264184,869449,580866,770421,358985,267552,1011023,1001309,568896,1028034,153445,582240,1035962,1036283,109248,371159,323545,403991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]