SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416879 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416879 [ RunTime:0.002200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536823,132534,582174,91098,250026,1038199,461143,289783,403627,1022614,984514,299522,569099,81350,568928,7305,407627,145105,987579,693231,183143,40674,669354,473292,121672,523914,151450,141558,353143,964597,852704,691645,394743,245097,990808,880825,482211,545824,63171,490083,210848,193493,984348,1025259,70354,96789,112232,729896,880949,258304,495213,102139,859023,314829,997938,682395,494329,128218,508666,341458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]