SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508022 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508022 [ RunTime:0.004078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303838,118227,1015238,141485,851080,773946,99714,571716,256833,870820,88440,712941,251551,201595,213972,571084,711799,762619,685947,247332,750591,314275,878951,38789,576701,811123,870970,772853,911953,771613,189768,132777,169516,226166,72109,251904,864210,211645,154276,989243,743244,95162,756379,306858,462214,457035,794166,451329,923437,454197,1010135,634858,616681,381445,325884,294746,608730,226864,671313,362636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003729s ]