SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467317 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467317 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988550,102940,1038968,669779,788305,1009799,740951,894104,12234,848223,893334,378364,1010638,920703,345234,633195,325315,291464,203573,773054,966784,125146,213234,995001,400208,594898,765294,100433,415653,106856,704008,850861,804969,945674,555729,917509,117226,235785,45703,799386,868423,197982,405114,865271,1029455,815818,1004372,999742,270128,363712,320057,283278,629077,426303,428051,78441,285907,57445,505421,975429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]