SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504411 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504411 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910845,834806,329915,942102,898888,529595,584340,832890,853687,586845,710560,771040,78749,1045864,518929,474967,885361,723610,281010,141214,795025,138541,226437,1017683,475582,594705,593157,770631,284496,716694,161555,931930,285386,704741,151724,467622,753261,1024489,729584,413277,427113,22156,839804,72170,495649,415868,370160,746016,38642,109561,848092,903342,640115,936429,137327,158605,968561,678685,998216,867736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]