SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498280 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498280 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59438,331012,1046902,70974,464727,18564,325118,462342,820082,107870,920751,745461,76914,684643,959186,457534,675927,16223,688592,865607,700897,310014,1046583,546994,947531,96839,234992,214485,490535,988824,834255,781279,596379,246407,912663,190187,748969,161739,753454,115908,827567,841157,1024116,996402,519083,20623,851150,1035432,1016421,759424,557012,341081,425696,145004,557923,1030466,847678,906772,297678,200987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]