SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510598 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510598 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937344,493264,215318,678187,637039,1048728,386632,770555,398428,251902,826740,116322,41318,858151,525386,711679,30405,429185,26552,1006599,608528,665774,605751,712766,806018,805959,644089,215192,334876,834919,1035580,550758,477018,473881,939453,874567,793471,995772,42744,574635,654932,72211,377190,137594,3516,194287,474470,603591,247183,57707,270638,989035,316822,429388,620240,277499,526285,519857,415128,266037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]