SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586917 LIMIT 1 [ RunTime:0.000703s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586917 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200394,333626,817883,769677,563845,983886,275645,244444,363729,954544,509598,699650,249132,181502,1006364,290589,528432,234397,567225,106373,1012695,868857,937759,26721,960827,501236,887463,413135,704297,91686,416812,179311,578286,674711,621194,1009461,751962,349661,1035167,995103,451055,515350,484110,686330,649274,194184,121943,979201,915542,377320,400675,909890,113531,739641,177360,823692,927794,553629,837180,648663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]