SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001723s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528843 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528843 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961799,915805,662923,29251,863134,911432,636732,510769,1005766,871933,30697,434673,37291,1031521,299469,356210,728509,782119,606806,219386,886787,430923,706963,908116,818,197418,284595,607082,358034,541656,288069,1009357,76718,671822,956975,615608,428801,528091,119185,551508,36119,572813,338631,388166,481369,44620,217110,81580,343705,290182,224403,485131,1006604,717858,504648,13761,325301,959492,12497,637340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]