SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421101 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421101 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438725,963594,2728,106682,451715,518153,297250,221785,153633,746073,82078,641595,644201,559124,764643,304029,559204,606525,670592,851231,705326,701315,538312,620050,533150,749423,736636,988451,25420,580576,11908,404195,824369,82662,11603,883412,697187,550680,103915,271091,388888,67469,223665,512084,45343,817799,416013,260415,701987,601536,146925,429699,638174,442381,399827,656159,1017660,560186,646229,934185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]