SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500031 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500031 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345610,634960,542882,2581,56138,827691,493712,916527,123575,402706,655718,201453,965766,963939,160665,829685,19697,409378,330596,192345,189686,1005235,1006757,250947,323129,79140,105688,828362,550150,125169,545086,512520,350516,211538,917562,616370,519842,534824,245309,274184,204733,738937,144209,978425,310399,767208,891464,884841,470546,567364,770507,694794,687226,1003252,1043766,220216,521189,214562,1013425,639716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]