SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511638 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511638 [ RunTime:0.002569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226419,455572,939559,425088,754657,1025022,209191,129560,798048,1036395,210923,461535,859020,503355,338868,538700,667216,657405,82144,700170,200395,464418,475691,291141,348007,964529,765107,22724,50647,215217,538255,552285,740240,927210,826365,425974,90761,405878,101325,927279,543680,500624,594278,634531,763382,154614,88290,914816,230645,991128,400097,359594,300277,1027290,862397,779456,788557,211343,8537,978766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001171s ]