SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515617 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515617 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14365,319099,456309,229482,421386,698364,286304,23498,768345,256083,476471,511764,424062,921005,184785,800499,810444,652135,782831,18727,713230,317125,729992,973845,591641,1031747,869234,82217,887500,937342,110973,174594,506107,978913,732436,361438,972603,39098,715085,806650,718869,539371,151758,1004766,81800,953917,440909,914641,113281,151458,74547,204790,219689,28356,599557,273715,494944,525313,821818,541207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000786s ]