SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047540 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047540 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701832,955087,185279,144215,160210,979740,229918,745148,372273,311533,146365,823677,425033,465987,303605,193898,544763,19939,199398,967377,716278,769558,941757,846478,845446,519407,838631,173345,129045,976453,138517,510557,350219,20002,458226,186821,818041,680327,1016941,396736,56778,657417,238879,90766,171393,176612,771075,482086,544211,572220,210284,286638,712098,388052,90598,379417,409063,672453,348782,545859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]