SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526470 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526470 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100982,903802,370449,939723,586006,854659,320148,1019564,1011597,118110,158207,966223,421610,782809,772031,304594,741908,877939,742492,816081,674642,252740,966809,968069,617454,103404,1007891,329187,734306,448667,223255,831918,416933,653764,1045678,310507,112436,254565,451231,584352,842788,241447,242838,649724,76647,813070,159255,643945,465993,562534,1041613,373818,559278,9345,496032,305145,896182,903892,976344,853171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]