SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531694 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531694 [ RunTime:0.002367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004205,637106,16915,555318,501114,228847,88940,904355,1030152,664807,315976,368067,720616,1003338,438607,64688,575355,977810,1029543,179524,762082,809120,612731,692860,610023,867476,573346,456385,276948,393789,396001,587160,267458,176191,54176,668494,480195,707076,282003,843293,693384,901884,80816,877454,159536,711867,913203,733785,1006235,231110,616755,500758,467517,882301,71472,411155,794156,440362,1024144,491746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]