SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101876 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101876 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525350,393585,64649,643263,33650,672213,670694,1046065,483541,166790,330416,593041,139182,51114,57013,495320,188809,771193,874641,628331,47295,941219,997415,386881,513641,651000,451418,207471,881765,601215,595605,231455,152550,37777,641068,597061,702351,929023,168761,520737,167063,59273,224462,966336,663317,422506,975605,767472,736411,1022262,536001,508827,657775,593127,738227,333694,1021999,823328,61302,811131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]