SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393523 LIMIT 1 [ RunTime:0.000877s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393523 [ RunTime:0.002456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73115,282772,1044970,882583,131490,462718,923007,428854,752722,934726,1012644,206795,143089,141643,966231,262416,872767,819107,110792,455499,304008,78065,629329,780570,687273,61157,52006,330097,874010,739298,529262,506456,570827,1039320,1038387,109088,1022358,1028831,782063,71065,340769,909294,434959,440554,101335,852275,822536,178256,944005,154153,559781,861074,472130,871503,56497,850145,385362,1008225,732190,1040478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]