SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499568 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499568 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470945,148648,489734,310444,444909,413541,133778,1000383,777447,179951,430799,117635,782850,997446,696125,501399,1026235,820791,174999,163353,761910,1045443,442952,229647,628280,541216,663330,393987,67583,461255,881757,284985,325330,886342,141436,912016,88733,824059,259629,652038,1026341,577425,491333,200444,949475,1000062,580519,626687,130334,621882,226251,194389,561877,978099,539258,659958,307685,202457,524225,25852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]