SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005061s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193103 LIMIT 1 [ RunTime:0.000973s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193103 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430401,384117,381878,983896,951605,899977,584449,129334,105622,577332,558215,7914,710821,344759,269554,694927,333133,406640,774050,483412,372115,634501,820566,174873,757879,133098,416275,147641,75573,990804,235590,889968,353748,435678,569155,262843,1023936,349692,573126,571940,574864,225591,704509,53158,306442,367725,805799,583882,701209,364283,137962,929603,811289,30031,959444,575950,224881,540964,1039382,270671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]